I'm still guessing here, because you still have not explained exactly how your data looks. Also, you use the word "form" when you mean "document", and formula language is bad enough without extra helpings of parentheses. Anyway, my guess is that your Status and Department fields are in your Request form. If that is the case, then try:
SELECT Form = "Request" & Status = "Request Approved" & Department = "Audit" | Form = "Holiday"
Return to top
. . . . . . RE: Views (~Kirk Elreterod... 7.Jan.04) 
Print this page
